Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
EffectiveDate (PK) | The date from which this assignment applies. | DC_EF | EffectiveDate | date | |
SiteID (FK)(PK) | Token ID for a Site | ID_STE | Identity | integer | Site(LO_STE) |
WorkstationNumber | An alternate key for the Workstation (while it is assigned to the Site) | NO_WS | Identity | integer | |
ExpirationDate | The date until which this assignment applies. | DC_EP | ExpirationDate | date | |